package com.keke.ado.bill;

import com.keke.pojo.Bill;

import java.sql.Connection;
import java.sql.SQLException;
import java.util.List;

public interface billDao {

    //增加订单
    int add(Connection connection, Bill bill)throws Exception;

    //通过查询条件获取供应商列表-模糊查询-getBillList
    List<Bill> getBillList(Connection connection,Bill bill,int currentPageNo, int pageSize) throws Exception;

    //通过delId删除Bill
    int deleteBillById(Connection connection,String delId) throws  Exception;

    //通过billId获取Bill
    Bill getBillById(Connection connection,String id) throws Exception;

    //修改订单信息
    int modifyBill(Connection connection,Bill bill)throws Exception;

    //根据供应商ID查询订单查询订单数量
    int getBillCountByProviderId(Connection connection,String providerId)throws Exception;

    public int getBillCount(Connection connection, String productName, int ProviderId,int isPayment) throws SQLException;
}
